/**
 * Year list
 * 
 * Research topic and the student wich chooise a reseach topic have to got a relation with a year
 * 
 * columns : 
 * 1. createdAt : start time , 
 * 2. dead_line : end time, 
 * 3. type : 0( means that this year is bound with research topics and student wich will chooise research topic), 1( means that this year is bound with student practice)
 * 4. id
 * 5. many reserve columns
 */



const Sequelize = require('sequelize');
const MySQLManager = require('../utils/MySQLManager');


const Years = MySQLManager.define('years', {

	  dead_line: {
        type: Sequelize.DATE,
        unique: true,
		    allowNull: false
      },

	//   1实习，0入所
	  type: {
		type: Sequelize.STRING,
		allowNull: false
	  },
	  
	  name: {
		type: Sequelize.STRING,
		// unique: true,
		allowNull: false
      },
    

    //   备用字段
	//   beiyong1: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong2: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong3: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong4: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong5: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong6: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong7: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong8: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong9: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong10: {
	// 	type: Sequelize.STRING
	//   }
});


module.exports = Years

